SELECT *, CASE WHEN `name` LIKE "orchard park%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "orchard park" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "orchard park" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "orchard park" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("orchard park") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,500,0005265 Big Tree RdOrchard Park NY 14127View Listing
$1,995,0007 Woodcrest DrOrchard Park NY 14127View Listing
$1,500,0003958 Southwestern BlvdOrchard Park NY 14127View Listing
$1,200,0006731 Chestnut Ridge RdOrchard Park NY 14127View Listing
$1,175,0009 Aaron TrlOrchard Park NY 14127View Listing
$1,000,0003964 Southwestern BlvdOrchard Park NY 14127View Listing
$999,99968 Birdsong PkwyOrchard Park NY 14127View Listing
$999,9002 Hidden Oak CtOrchard Park NY 14127View Listing
$999,0005797 Chestnut Ridge RdOrchard Park NY 14127View Listing
$989,9007424 Jewett Holmwood RdOrchard Park NY 14127View Listing
$899,9003 Blue HeronOrchard Park NY 14127View Listing
$899,90032 Furlong DrOrchard Park NY 14127View Listing
$899,00045 Deer RunOrchard Park NY 14127View Listing
$889,90044 Woodthrush TrlOrchard Park NY 14127View Listing
$869,90011 Cambridge CtOrchard Park NY 14127View Listing
$849,9002 Grand View TrlOrchard Park NY 14127View Listing
$829,90014 Blue HeronOrchard Park NY 14127View Listing
$755,0002 Hampton CtOrchard Park NY 14127View Listing
$750,0006545 Chestnut Ridge RdOrchard Park NY 14127View Listing
$729,9001 Blue HeronOrchard Park NY 14127View Listing
$729,9007975 Jewett Holmwood RdOrchard Park NY 14127View Listing
$700,0006362 Scherff RdOrchard Park NY 14127View Listing
$699,9004596 Freeman RdOrchard Park NY 14127View Listing
$679,90015 Wentworth DrOrchard Park NY 14127View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-08-2024 11:21:58 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Ranch
Single Family
